Hi all,

With the changes to the behaviour of Application.Visible = True in the new Single Document Interface we seem to have encountered a use case that causes some quirky behaviour.

With a hidden workbook, if we set Application.Visible = True it will display the window for that hidden workbook (http://msdn.microsoft.com/en-us/library/office/dn251093.aspx) - not too big of an issue. However we cannot seem to then close this workbook using the X at the top or at the taskbar, only thing that works is a process kill.

To replicate this:

1. Open new Excel
2. Save the workbook (xlsx is fine)
3. Hide active worbook (View > Hide)
4. Close Excel (save when prompted) 
5. Re-open
6. In the VBE Immediate window 'Application.Visible = True'
7. Try to close window

For our product we have the hidden workbook as a core 'functions' workbook and do steps 5 & 6 through C# and other visible template files.

We don't want to remove the Application.Visible = True line because that's not really the problem i.e. it works for non-hidden workbooks.

Does anyone around here or the MS tech guys have a workaround for this? Users are able to close the templates fine but come to a huge annoyance when the X doesn't work for this 'functions' workbook.

Thanks!

Eugene

Tested. I cannot close the single workbook either after setting Application.Visible = True. However I could close the whole Excel file without problem.

Please hold the Ctrl and Launch Excel.exe in another instance to check the result.

Tony Chen
TechNet Community Support

Thanks for looking into this Tony. Is there a fix in the pipeline for this? If so, when can we anticipate this to be fixed?

No. Hope that there would be a hotfix released to fix it.

Tony Chen
TechNet Community Support

Thanks for the prompt reply. 

We've got many clients that are holding back on upgrading to 2013 because of this. Is there anyway of getting 'hope' to 'will'? Will raising our action packs help?